Pandas Profiling Report

Dataset statistics

Number of variables	79
Number of observations	9006
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	2
Duplicate rows (%)	< 0.1%
Total size in memory	1.4 MiB
Average record size in memory	163.0 B

Variable types

BOOL	67
NUM	8
CAT	4

Warnings

Dataset has 2 (< 0.1%) duplicate rows	Duplicates
`zip_code` has a high cardinality: 182 distinct values	High cardinality
`on_street_name` has a high cardinality: 2525 distinct values	High cardinality
`off_street_name` has a high cardinality: 1694 distinct values	High cardinality
`day_of_week` is highly correlated with `day`	High correlation
`day` is highly correlated with `day_of_week`	High correlation
`hour` has 396 (4.4%) zeros	Zeros
`minute` has 1605 (17.8%) zeros	Zeros

Reproduction

Analysis started	2020-12-11 13:48:42.856272
Analysis finished	2020-12-11 13:49:29.703152
Duration	46.85 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

zip_code
Categorical

HIGH CARDINALITY

Distinct	182
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Memory size	70.4 KiB

-1	2974
11207	152
11236	121
11208	115
11212	108
Other values (177)	5536

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
-1	2974	33.0%
11207	152	1.7%
11236	121	1.3%
11208	115	1.3%
11212	108	1.2%
10467	95	1.1%
11226	92	1.0%
11203	89	1.0%
11385	88	1.0%
10457	84	0.9%
Other values (172)	5088	56.5%

Frequencies of value counts

Unique

Unique	5 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	5
Median length	5
Mean length	4.009327115
Min length	2

latitude
Real number (ℝ_≥0)

Distinct	7248
Distinct (%)	80.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	40.72793471
Minimum	40.507267
Maximum	40.9109
Zeros	0
Zeros (%)	0.0%
Memory size	70.4 KiB

Quantile statistics

Minimum	40.507267
5-th percentile	40.599623
Q1	40.6659715
median	40.7168915
Q3	40.8020705
95-th percentile	40.8657445
Maximum	40.9109
Range	0.403633
Interquartile range (IQR)	0.136099

Descriptive statistics

Standard deviation	0.08376902426
Coefficient of variation (CV)	0.00205679529
Kurtosis	-0.8907520713
Mean	40.72793471
Median Absolute Deviation (MAD)	0.0599115
Skewness	0.1615208588
Sum	366795.78
Variance	0.007017249426
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.861862	13	0.1%
40.84519	9	0.1%
40.84518	9	0.1%
40.76635	8	0.1%
40.675735	8	0.1%
40.820305	8	0.1%
40.65616	7	0.1%
40.66496	6	0.1%
40.733536	6	0.1%
40.651974	6	0.1%
Other values (7238)	8926	99.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
40.507267	1	< 0.1%
40.511734	1	< 0.1%
40.516624	1	< 0.1%
40.519127	1	< 0.1%
40.519722	1	< 0.1%

Value	Count	Frequency (%)
40.9109	1	< 0.1%
40.91076	1	< 0.1%
40.91038	1	< 0.1%
40.91032	1	< 0.1%
40.909607	1	< 0.1%

longitude
Real number (ℝ)

Distinct	6864
Distinct (%)	76.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-73.91336268
Minimum	-74.23878
Maximum	-73.70174
Zeros	0
Zeros (%)	0.0%
Memory size	70.4 KiB

Quantile statistics

Minimum	-74.23878
5-th percentile	-74.02221875
Q1	-73.9586965
median	-73.91749
Q3	-73.8680625
95-th percentile	-73.7626825
Maximum	-73.70174
Range	0.53704
Interquartile range (IQR)	0.090634

Descriptive statistics

Standard deviation	0.08299945637
Coefficient of variation (CV)	-0.001122928972
Kurtosis	1.211668832
Mean	-73.91336268
Median Absolute Deviation (MAD)	0.045295
Skewness	-0.3017397742
Sum	-665663.7443
Variance	0.006888909757
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-73.91282	14	0.2%
-73.9112	11	0.1%
-73.91417	9	0.1%
-73.89686	9	0.1%
-73.89083	8	0.1%
-73.76736	7	0.1%
-73.897736	7	0.1%
-73.919106	7	0.1%
-73.94194	7	0.1%
-73.922676	6	0.1%
Other values (6854)	8921	99.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-74.23878	1	< 0.1%
-74.23591	1	< 0.1%
-74.235115	1	< 0.1%
-74.23486	1	< 0.1%
-74.230446	1	< 0.1%

Value	Count	Frequency (%)
-73.70174	1	< 0.1%
-73.70212	1	< 0.1%
-73.70259	1	< 0.1%
-73.70362	1	< 0.1%
-73.70631	1	< 0.1%

on_street_name
Categorical

HIGH CARDINALITY

Distinct	2525
Distinct (%)	28.0%
Missing	0
Missing (%)	0.0%
Memory size	70.4 KiB

Belt Parkway	168
Broadway	99
Brooklyn Queens Expressway	90
Long Island Expressway	83
Atlantic Avenue	82
Other values (2520)	8484

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Belt Parkway	168	1.9%
Broadway	99	1.1%
Brooklyn Queens Expressway	90	1.0%
Long Island Expressway	83	0.9%
Atlantic Avenue	82	0.9%
Cross Bronx Expy	82	0.9%
Major Deegan Expressway	79	0.9%
Fdr Drive	77	0.9%
Grand Central Pkwy	77	0.9%
3 Avenue	70	0.8%
Other values (2515)	8099	89.9%

Frequencies of value counts

Unique

Unique	1329 ?
Unique (%)	14.8%

Histogram of lengths of the category

Length

Max length	32
Median length	14
Mean length	14.46824339
Min length	6

off_street_name
Categorical

HIGH CARDINALITY

Distinct	1694
Distinct (%)	18.8%
Missing	0
Missing (%)	0.0%
Memory size	70.4 KiB

Unknown	4869
3 Avenue	39
Broadway	38
2 Avenue	34
4 Avenue	24
Other values (1689)	4002

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Unknown	4869	54.1%
3 Avenue	39	0.4%
Broadway	38	0.4%
2 Avenue	34	0.4%
4 Avenue	24	0.3%
5 Avenue	24	0.3%
Queens Boulevard	20	0.2%
Atlantic Avenue	20	0.2%
Park Avenue	19	0.2%
Linden Boulevard	17	0.2%
Other values (1684)	3902	43.3%

Frequencies of value counts

Unique

Unique	884 ?
Unique (%)	9.8%

Histogram of lengths of the category

Length

Max length	29
Median length	7
Mean length	9.774483678
Min length	6

year
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	70.4 KiB

2020	9005
2017	1

Frequencies
Length

Value	Count	Frequency (%)
2020	9005	> 99.9%
2017	1	< 0.1%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	4
Median length	4
Mean length	4
Min length	4

month
Real number (ℝ_≥0)

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	10.63535421
Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Memory size	70.4 KiB

Quantile statistics

Minimum	1
5-th percentile	10
Q1	10
median	11
Q3	11
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.6422565041
Coefficient of variation (CV)	0.06038882123
Kurtosis	8.87277373
Mean	10.63535421
Median Absolute Deviation (MAD)	0
Skewness	-0.9969686728
Sum	95782
Variance	0.412493417
Monotocity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
11	4905	54.5%
10	3534	39.2%
12	492	5.5%
7	26	0.3%
8	23	0.3%
9	22	0.2%
6	3	< 0.1%
1	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
6	3	< 0.1%
7	26	0.3%
8	23	0.3%
9	22	0.2%

Value	Count	Frequency (%)
12	492	5.5%
11	4905	54.5%
10	3534	39.2%
9	22	0.2%
8	23	0.3%

day
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	31
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	16.60570731
Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Memory size	70.4 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	10
median	17
Q3	24
95-th percentile	30
Maximum	31
Range	30
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	8.70995312
Coefficient of variation (CV)	0.5245156355
Kurtosis	-1.070602243
Mean	16.60570731
Median Absolute Deviation (MAD)	7
Skewness	-0.1693293974
Sum	149551
Variance	75.86328336
Monotocity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
20	408	4.5%
13	392	4.4%
21	376	4.2%
30	368	4.1%
12	351	3.9%
24	348	3.9%
14	347	3.9%
23	336	3.7%
18	327	3.6%
4	324	3.6%
Other values (21)	5429	60.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	305	3.4%
2	279	3.1%
3	281	3.1%
4	324	3.6%
5	219	2.4%

Value	Count	Frequency (%)
31	168	1.9%
30	368	4.1%
29	318	3.5%
28	299	3.3%
27	298	3.3%

day_of_week
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	31
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	16.60570731
Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Memory size	70.4 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	10
median	17
Q3	24
95-th percentile	30
Maximum	31
Range	30
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	8.70995312
Coefficient of variation (CV)	0.5245156355
Kurtosis	-1.070602243
Mean	16.60570731
Median Absolute Deviation (MAD)	7
Skewness	-0.1693293974
Sum	149551
Variance	75.86328336
Monotocity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
20	408	4.5%
13	392	4.4%
21	376	4.2%
30	368	4.1%
12	351	3.9%
24	348	3.9%
14	347	3.9%
23	336	3.7%
18	327	3.6%
4	324	3.6%
Other values (21)	5429	60.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	305	3.4%
2	279	3.1%
3	281	3.1%
4	324	3.6%
5	219	2.4%

Value	Count	Frequency (%)
31	168	1.9%
30	368	4.1%
29	318	3.5%
28	299	3.3%
27	298	3.3%

week
Real number (ℝ_≥0)

Distinct	25
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	45.04585832
Minimum	3
Maximum	49
Zeros	0
Zeros (%)	0.0%
Memory size	70.4 KiB

Quantile statistics

Minimum	3
5-th percentile	42
Q1	43
median	45
Q3	47
95-th percentile	49
Maximum	49
Range	46
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.518781434
Coefficient of variation (CV)	0.0559159383
Kurtosis	14.53478873
Mean	45.04585832
Median Absolute Deviation (MAD)	2
Skewness	-1.634154283
Sum	405683
Variance	6.344259913
Monotocity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
45	1308	14.5%
44	1216	13.5%
42	1208	13.4%
43	1189	13.2%
46	1187	13.2%
47	1112	12.3%
48	988	11.0%
49	638	7.1%
41	81	0.9%
36	8	0.1%
Other values (15)	71	0.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3	1	< 0.1%
26	3	< 0.1%
27	4	< 0.1%
28	8	0.1%
29	5	0.1%

Value	Count	Frequency (%)
49	638	7.1%
48	988	11.0%
47	1112	12.3%
46	1187	13.2%
45	1308	14.5%

hour
Real number (ℝ_≥0)

ZEROS

Distinct	24
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	13.09882301
Minimum	0
Maximum	23
Zeros	396
Zeros (%)	4.4%
Memory size	70.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	9
median	14
Q3	18
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	6.111803487
Coefficient of variation (CV)	0.4665918063
Kurtosis	-0.5519085993
Mean	13.09882301
Median Absolute Deviation (MAD)	4
Skewness	-0.4683298978
Sum	117968
Variance	37.35414187
Monotocity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
17	614	6.8%
14	585	6.5%
18	566	6.3%
15	554	6.2%
16	545	6.1%
13	508	5.6%
19	497	5.5%
12	491	5.5%
11	449	5.0%
20	415	4.6%
Other values (14)	3782	42.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	396	4.4%
1	202	2.2%
2	154	1.7%
3	132	1.5%
4	135	1.5%

Value	Count	Frequency (%)
23	290	3.2%
22	335	3.7%
21	326	3.6%
20	415	4.6%
19	497	5.5%

minute
Real number (ℝ_≥0)

ZEROS

Distinct	60
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	24.74727959
Minimum	0
Maximum	59
Zeros	1605
Zeros (%)	17.8%
Memory size	70.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	10
median	25
Q3	40
95-th percentile	54
Maximum	59
Range	59
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	17.98067569
Coefficient of variation (CV)	0.7265718086
Kurtosis	-1.204831036
Mean	24.74727959
Median Absolute Deviation (MAD)	15
Skewness	0.0908492937
Sum	222874
Variance	323.3046983
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1605	17.8%
30	1140	12.7%
20	471	5.2%
50	463	5.1%
45	462	5.1%
15	459	5.1%
40	417	4.6%
10	383	4.3%
25	255	2.8%
35	241	2.7%
Other values (50)	3110	34.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1605	17.8%
1	46	0.5%
2	47	0.5%
3	44	0.5%
4	64	0.7%

Value	Count	Frequency (%)
59	48	0.5%
58	67	0.7%
57	54	0.6%
56	57	0.6%
55	223	2.5%

Bronx
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	7761
1	1245

Common Values
Chart

Value	Count	Frequency (%)
0	7761	86.2%
1	1245	13.8%

Brooklyn
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	6927
1	2079

Common Values
Chart

Value	Count	Frequency (%)
0	6927	76.9%
1	2079	23.1%

Manhattan
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8134
1	872

Common Values
Chart

Value	Count	Frequency (%)
0	8134	90.3%
1	872	9.7%

Queens
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	7383
1	1623

Common Values
Chart

Value	Count	Frequency (%)
0	7383	82.0%
1	1623	18.0%

Staten Island
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8793
1	213

Common Values
Chart

Value	Count	Frequency (%)
0	8793	97.6%
1	213	2.4%

Accelerator Defective
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8999
1	7

Common Values
Chart

Value	Count	Frequency (%)
0	8999	99.9%
1	7	0.1%

Aggressive Driving/Road Rage
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8924
1	82

Common Values
Chart

Value	Count	Frequency (%)
0	8924	99.1%
1	82	0.9%

Alcohol Involvement
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8858
1	148

Common Values
Chart

Value	Count	Frequency (%)
0	8858	98.4%
1	148	1.6%

Animals Action
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8995
1	11

Common Values
Chart

Value	Count	Frequency (%)
0	8995	99.9%
1	11	0.1%

Backing Unsafely
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8721
1	285

Common Values
Chart

Value	Count	Frequency (%)
0	8721	96.8%
1	285	3.2%

Brakes Defective
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8965
1	41

Common Values
Chart

Value	Count	Frequency (%)
0	8965	99.5%
1	41	0.5%

Cell Phone (Hand-Held)
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	9001
1	5

Common Values
Chart

Value	Count	Frequency (%)
0	9001	99.9%
1	5	0.1%

Driver Inattention/Distraction
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	6629
1	2377

Common Values
Chart

Value	Count	Frequency (%)
0	6629	73.6%
1	2377	26.4%

Driver Inexperience
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8811
1	195

Common Values
Chart

Value	Count	Frequency (%)
0	8811	97.8%
1	195	2.2%

Driverless/Runaway Vehicle
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8996
1	10

Common Values
Chart

Value	Count	Frequency (%)
0	8996	99.9%
1	10	0.1%

Drugs (Illegal)
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8996
1	10

Common Values
Chart

Value	Count	Frequency (%)
0	8996	99.9%
1	10	0.1%

Failure To Keep Right
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8996
1	10

Common Values
Chart

Value	Count	Frequency (%)
0	8996	99.9%
1	10	0.1%

Failure To Yield Right-Of-Way
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8367
1	639

Common Values
Chart

Value	Count	Frequency (%)
0	8367	92.9%
1	639	7.1%

Fatigued/Drowsy
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8996
1	10

Common Values
Chart

Value	Count	Frequency (%)
0	8996	99.9%
1	10	0.1%

Fell Asleep
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8980
1	26

Common Values
Chart

Value	Count	Frequency (%)
0	8980	99.7%
1	26	0.3%

Following Too Closely
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8458
1	548

Common Values
Chart

Value	Count	Frequency (%)
0	8458	93.9%
1	548	6.1%

Glare
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8993
1	13

Common Values
Chart

Value	Count	Frequency (%)
0	8993	99.9%
1	13	0.1%

Headlights Defective
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	9004
1	2

Common Values
Chart

Value	Count	Frequency (%)
0	9004	> 99.9%
1	2	< 0.1%

Illnes
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8995
1	11

Common Values
Chart

Value	Count	Frequency (%)
0	8995	99.9%
1	11	0.1%

Lane Marking Improper/Inadequate
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	9002
1	4

Common Values
Chart

Value	Count	Frequency (%)
0	9002	> 99.9%
1	4	< 0.1%

Lost Consciousness
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8991
1	15

Common Values
Chart

Value	Count	Frequency (%)
0	8991	99.8%
1	15	0.2%

Obstruction/Debris
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8978
1	28

Common Values
Chart

Value	Count	Frequency (%)
0	8978	99.7%
1	28	0.3%

Other Electronic Device
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	9005
1	1

Common Values
Chart

Value	Count	Frequency (%)
0	9005	> 99.9%
1	1	< 0.1%

Other Lighting Defects
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	9005
1	1

Common Values
Chart

Value	Count	Frequency (%)
0	9005	> 99.9%
1	1	< 0.1%

Other Vehicular
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8704
1	302

Common Values
Chart

Value	Count	Frequency (%)
0	8704	96.6%
1	302	3.4%

Outside Car Distraction
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8985
1	21

Common Values
Chart

Value	Count	Frequency (%)
0	8985	99.8%
1	21	0.2%

Oversized Vehicle
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8958
1	48

Common Values
Chart

Value	Count	Frequency (%)
0	8958	99.5%
1	48	0.5%

Passenger Distraction
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8985
1	21

Common Values
Chart

Value	Count	Frequency (%)
0	8985	99.8%
1	21	0.2%

Passing Or Lane Usage Improper
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8667
1	339

Common Values
Chart

Value	Count	Frequency (%)
0	8667	96.2%
1	339	3.8%

Passing Too Closely
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8652
1	354

Common Values
Chart

Value	Count	Frequency (%)
0	8652	96.1%
1	354	3.9%

Pavement Defective
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8992
1	14

Common Values
Chart

Value	Count	Frequency (%)
0	8992	99.8%
1	14	0.2%

Pavement Slippery
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8913
1	93

Common Values
Chart

Value	Count	Frequency (%)
0	8913	99.0%
1	93	1.0%

Pedestrian/Bicyclist/Other Pedestrian Error/Confusion
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8921
1	85

Common Values
Chart

Value	Count	Frequency (%)
0	8921	99.1%
1	85	0.9%

Physical Disability
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	9000
1	6

Common Values
Chart

Value	Count	Frequency (%)
0	9000	99.9%
1	6	0.1%

Prescription Medication
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	9005
1	1

Common Values
Chart

Value	Count	Frequency (%)
0	9005	> 99.9%
1	1	< 0.1%

Reaction To Uninvolved Vehicle
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8862
1	144

Common Values
Chart

Value	Count	Frequency (%)
0	8862	98.4%
1	144	1.6%

Shoulders Defective/Improper
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	9004
1	2

Common Values
Chart

Value	Count	Frequency (%)
0	9004	> 99.9%
1	2	< 0.1%

Steering Failure
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8981
1	25

Common Values
Chart

Value	Count	Frequency (%)
0	8981	99.7%
1	25	0.3%

Tinted Windows
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	9004
1	2

Common Values
Chart

Value	Count	Frequency (%)
0	9004	> 99.9%
1	2	< 0.1%

Tire Failure/Inadequate
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8985
1	21

Common Values
Chart

Value	Count	Frequency (%)
0	8985	99.8%
1	21	0.2%

Tow Hitch Defective
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	9005
1	1

Common Values
Chart

Value	Count	Frequency (%)
0	9005	> 99.9%
1	1	< 0.1%

Traffic Control Device Improper/Non-Working
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	9005
1	1

Common Values
Chart

Value	Count	Frequency (%)
0	9005	> 99.9%
1	1	< 0.1%

Traffic Control Disregarded
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8749
1	257

Common Values
Chart

Value	Count	Frequency (%)
0	8749	97.1%
1	257	2.9%

Turning Improperly
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8816
1	190

Common Values
Chart

Value	Count	Frequency (%)
0	8816	97.9%
1	190	2.1%

Unsafe Lane Changing
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8829
1	177

Common Values
Chart

Value	Count	Frequency (%)
0	8829	98.0%
1	177	2.0%

Unsafe Speed
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8664
1	342

Common Values
Chart

Value	Count	Frequency (%)
0	8664	96.2%
1	342	3.8%

Using On Board Navigation Device
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	9005
1	1

Common Values
Chart

Value	Count	Frequency (%)
0	9005	> 99.9%
1	1	< 0.1%

Vehicle Vandalism
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	9005
1	1

Common Values
Chart

Value	Count	Frequency (%)
0	9005	> 99.9%
1	1	< 0.1%

View Obstructed/Limited
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8917
1	89

Common Values
Chart

Value	Count	Frequency (%)
0	8917	99.0%
1	89	1.0%

Bike
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8540
1	466

Common Values
Chart

Value	Count	Frequency (%)
0	8540	94.8%
1	466	5.2%

Box Truck
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8681
1	325

Common Values
Chart

Value	Count	Frequency (%)
0	8681	96.4%
1	325	3.6%

Bus
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8783
1	223

Common Values
Chart

Value	Count	Frequency (%)
0	8783	97.5%
1	223	2.5%

E-Bike
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8883
1	123

Common Values
Chart

Value	Count	Frequency (%)
0	8883	98.6%
1	123	1.4%

E-Scooter
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8876
1	130

Common Values
Chart

Value	Count	Frequency (%)
0	8876	98.6%
1	130	1.4%

Motorcycle
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8879
1	127

Common Values
Chart

Value	Count	Frequency (%)
0	8879	98.6%
1	127	1.4%

Other
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8427
1	579

Common Values
Chart

Value	Count	Frequency (%)
0	8427	93.6%
1	579	6.4%

Pick-Up Truck
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8666
1	340

Common Values
Chart

Value	Count	Frequency (%)
0	8666	96.2%
1	340	3.8%

Sedan
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

1	5697
0	3309

Common Values
Chart

Value	Count	Frequency (%)
1	5697	63.3%
0	3309	36.7%

Station Wagon/Sport Utility Vehicle
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	4797
1	4209

Common Values
Chart

Value	Count	Frequency (%)
0	4797	53.3%
1	4209	46.7%

Taxi
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8642
1	364

Common Values
Chart

Value	Count	Frequency (%)
0	8642	96.0%
1	364	4.0%

Tractor Truck Diesel
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8855
1	151

Common Values
Chart

Value	Count	Frequency (%)
0	8855	98.3%
1	151	1.7%

Van
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.8 KiB

0	8887
1	119

Common Values
Chart

Value	Count	Frequency (%)
0	8887	98.7%
1	119	1.3%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

First rows

	zip_code	latitude	longitude	on_street_name	off_street_name	year	month	day	day_of_week	week	hour	minute	Brooklyn	Manhattan	Queens	Driver Inattention/Distraction	Fell Asleep	Other Vehicular	Turning Improperly	Bike	Sedan	Taxi
0	-1	40.798504	-73.967125	West 103 Street	Unknown	2020	12	3	3	49	13	37	0	0	0	0	0	0	0	0	0	0
1	-1	40.731167	-73.709940	256 Street	87 Avenue	2020	12	2	2	49	19	0	0	0	0	0	0	0	0	0	0	1
2	11375	40.735550	-73.850970	62-60 108 Street	Unknown	2020	11	30	30	49	9	40	0	0	1	0	0	0	0	0	0	0
3	-1	40.701527	-73.989570	Brooklyn Queens Expressway	Unknown	2020	11	29	29	48	5	45	0	0	0	0	1	0	0	0	1	0
4	-1	40.700108	-73.953830	Wallabout Street	Unknown	2020	11	26	26	48	23	30	0	0	0	1	0	0	0	0	1	0
5	11215	40.668293	-73.979240	6 Street	Unknown	2020	11	23	23	48	11	28	1	0	0	1	0	0	0	0	1	0
6	-1	40.624640	-74.141670	Forest Avenue	Decker Avenue	2020	11	22	22	47	20	10	0	0	0	0	0	0	0	0	0	0
7	-1	40.677483	-73.930330	Utica Avenue	Unknown	2020	11	20	20	47	12	0	0	0	0	1	0	1	0	1	0	1
8	10010	40.736706	-73.978220	East 23 Street	Unknown	2020	11	18	18	47	11	0	0	1	0	0	0	0	1	0	0	0
9	-1	40.608757	-74.038086	Verrazano Bridge Lower	Unknown	2017	1	17	17	3	3	2	0	0	0	0	0	0	0	0	1	0

Last rows

	zip_code	latitude	longitude	on_street_name	off_street_name	year	month	day	day_of_week	week	hour	minute	Bronx	Brooklyn	Manhattan	Queens	Driver Inattention/Distraction	Tire Failure/Inadequate	Bike	Box Truck	Sedan	Station Wagon/Sport Utility Vehicle
8996	11434	40.656160	-73.76736	Rockaway Boulevard	Brewer Boulevard	2020	11	2	2	45	12	20	0	0	0	1	0	0	0	0	0	1
8997	10468	40.860850	-73.90545	Aqueduct Avenue	Unknown	2020	11	4	4	45	18	0	1	0	0	0	0	0	0	0	0	1
8998	11433	40.704388	-73.77917	180 Street	105 Avenue	2020	11	12	12	46	18	20	0	0	0	1	1	0	0	0	1	1
8999	10031	40.829020	-73.94485	Amsterdam Avenue	West 151 Street	2020	11	18	18	47	7	30	0	0	1	0	1	0	0	0	1	0
9000	11217	40.686500	-73.98787	Hoyt Street	Dean Street	2020	11	13	13	46	21	43	0	1	0	0	0	0	0	0	1	0
9001	-1	40.658535	-73.97328	West Drive	Center Drive	2020	11	4	4	45	12	10	0	0	0	0	0	0	1	0	0	0
9002	11691	40.598297	-73.74828	14-05 New Haven Avenue	Unknown	2020	11	18	18	47	9	15	0	0	0	1	1	0	0	0	0	1
9003	11218	40.640415	-73.98593	39 Street	Unknown	2020	11	4	4	45	11	24	0	1	0	0	0	0	0	1	0	1
9004	11427	40.735300	-73.73681	82-25 234 Street	Unknown	2020	11	13	13	46	12	5	0	0	0	1	0	1	0	0	1	1
9005	11368	40.750225	-73.85515	111 Street	42 Avenue	2020	11	3	3	45	8	0	0	0	0	1	0	0	0	0	1	0

Most frequent

	zip_code	latitude	longitude	on_street_name	off_street_name	year	month	day	day_of_week	week	hour	minute	Bronx	Brooklyn	Manhattan	Queens	Staten Island	Accelerator Defective	Aggressive Driving/Road Rage	Alcohol Involvement	Animals Action	Backing Unsafely	Brakes Defective	Cell Phone (Hand-Held)	Driver Inattention/Distraction	Driver Inexperience	Driverless/Runaway Vehicle	Drugs (Illegal)	Failure To Keep Right	Failure To Yield Right-Of-Way	Fatigued/Drowsy	Fell Asleep	Following Too Closely	Glare	Headlights Defective	Illnes	Lane Marking Improper/Inadequate	Lost Consciousness	Obstruction/Debris	Other Electronic Device	Other Lighting Defects	Other Vehicular	Outside Car Distraction	Oversized Vehicle	Passenger Distraction	Passing Or Lane Usage Improper	Passing Too Closely	Pavement Defective	Pavement Slippery	Pedestrian/Bicyclist/Other Pedestrian Error/Confusion	Physical Disability	Prescription Medication	Reaction To Uninvolved Vehicle	Shoulders Defective/Improper	Steering Failure	Tinted Windows	Tire Failure/Inadequate	Tow Hitch Defective	Traffic Control Device Improper/Non-Working	Traffic Control Disregarded	Turning Improperly	Unsafe Lane Changing	Unsafe Speed	Using On Board Navigation Device	Vehicle Vandalism	View Obstructed/Limited	Bike	Box Truck	Bus	E-Bike	E-Scooter	Motorcycle	Other	Pick-Up Truck	Sedan	Station Wagon/Sport Utility Vehicle	Taxi	Tractor Truck Diesel	Van	count
0	11201	40.694794	-73.982796	Johnson Street	Unknown	2020	11	21	21	47	9	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	2
1	11205	40.698020	-73.974990	Flushing Avenue	Unknown	2020	11	5	5	45	16	30	0	1	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	1	0	0	0	0	2

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows

Duplicate rows

Most frequent